Skip Headers

Oracle® Transparent Gateway for DRDA Installation and User's Guide 10g Release 2 (10.2) for Microsoft Windows Part Number B16218-02 |
Home | Book List | Contents | Master Index | Feedback

Previous
| View PDF

# Index

A B C D E F G H I J K L M N O P Q R S T U V W Z

## A

  access method transparency (introduction), 1.3.1
  accessing
    DRDA Servers, 10.9
    gateway, 10.8
  action items of Oracle Universal Installer, 4.6.4
  Advanced Security
    CHECKSUM command, 9.5
    encryption
      export encryption algorithms, 9.5
      international version types supported, 9.6
      resetting configuration parameters on gateway, 9.7.2
      setting test parameters for gateway, 9.6.1
      setting test parameters for Oracle integrating server, 9.6.2
      setting up for test, 9.6
      testing gateway and Oracle integrating server, 9.7.1
    function on the gateway, 1.3.3
    test error
      error 12660, 9.6
      testing advanced security encryption, 9.7.1
  AGW ADD USERID command, 13.5.1.2
  AGW DELETE USERID command, 13.5.1.2
  AIX_RS6K, default value for DRDA_LOCAL_NODE_NAME, C.4.17
  alias
    DB2, C.4.9
    objects, DB2, known restrictions, 2.5
  ALL_CATALOG view, A.2.1
  ALL_COL_COMMENTS view, A.2.2
  ALL_CON_COLUMNS view, A.2.3
  ALL_CONSTRAINTS view, A.2.4
  ALL_DB_LINKS data dictionary view, 11.1.4
  ALL_INDEXES view, A.2.5
  ALL_OBJECTS view, A.2.7
  ALL_SYNONYMS view, A.2.8
  ALL_TAB_COMMENTS view, A.2.11
  ALL_TABLES view, A.2.9
  ALL_USERS view, A.2.12
  ALL_VIEWS view, A.2.13
  allocation mode, SNA session, DRDA_CMSRC_CM_IMMEDIATE, C.4.7
  ALTER session statement, 11.1.2
  ANSI-standard SQL
    gateway capabilities, 1.3.5
    heterogeneous database integration, 1.9.10
  API (application program interface), Oracle Net, 9.3
  APPC
    concurrent connections, 3.1.2
    configuring another profile, 10.9
    database link behavior, 12.4
    DB2/VM, 13.5.1.2
    mode definition, 6.4.3.6
    password length, 15.3
    user ID length, 15.3
  APPC VTAM Support (AVS)
    also see AVS, 13.5.1.2
    mapping user ID, 2.5.1
  APPEND command
    supported by COPY, 11.8
  application
    application program interface defined, see API, 9.3
    authenticating logons, 13.2
    development on the gateway, 1.9.16
    portability, 1.9.13
    server support, 1.3.3
  architecture of the gateway, 1.5
  array size
    fetch reblocking, 1.9.3
    how determined, 12.1.1
  AS/400
    command DSPRDBDIRE, 5.3.4
    configuring communications, 5.3.1
    defining user ID, 5.3.2
    library name, DRDA_PACKAGE_COLLID, C.4.20
  ASCII
    code page, D.3
    sort order, 12.6.2
    tables, known restrictions, 1.9.21
    translated from EBCDIC, 12.7.1
    US7ASCII, D.3.2.1
    US7ASCII, NLS, D.2
  authority
    CONNECT, 13.5.1.2
    execute, 13.5.1.2
  autonomy, site, 1.3.14
  AVS
    also see APPC VTAM Support, 2.5.1
    configuring, 5.5.1
    DB2/VM, 13.5.1.2
    mapping user IDs (DB2/VM), 2.5.1
    user ID mapping, 13.5.1.2

## B

  binary data, non-character, 12.7.1
  Bind Package Stored Procedure
    DB2/400, 5.3.2
    DB2/OS390, 5.2.2
    DB2/UDB, 5.4.2
    DB2/VM, 5.5.2
  bind privilege
    configuration worksheet, E
    DB2/400, 5.3.2
    DB2/OS390, 5.2.2
    DB2/UDB, 5.4.2
    DB2/VM, 5.5.2
  bind variables
    native SQL passthrough, 12.8
    restrictions, 2.5.2
  BINDADD authority, binding packages on DB2/UDB, 10.4.5
  BINDADD privilege
    configuration worksheet, E
    DB2/OS390, 5.2.2
    DB2/UDB, 5.4.2
    DB2/VM, 5.5.2
  BINDAGENT privilege
    configuration worksheet, E
    DB2/OS390, 5.2.2
    DB2/VM, 5.5.2
  binding the DRDA package
    authority of user ID and password
      DB2/400, 5.3.2
      DB2/OS390, 5.2.2
      DB2/UDB, 5.4.2
      DB2/VM, 5.5.2
    backward compatibility, 14.4
    configuring the host, 10.4.4
    on DB2/UDB, 10.4.5
    upgrading from version 3, 10.4.5
  bug
    bugs fixed in release 10.1.0.2.0, 2.3
    debugging
      drc values used by Oracle Support Services, 15.1.3
      setting trace parameters, 15.4
      SQL tracing reduces gateway performance, 11.10
    number 205538, 2.5.2

## C

  call
    a CICS or IMS transaction, 12.3.2
    DB2 stored procedure
      DRDA Server definition, 12.3
      look up in server catalog, 12.3.1
    DRDA_DISABLE_CALL
      default, 10.5.1.1
      sample Gateway Initialization File, B.1
    empproc stored procedure, 12.3
    Oracle Call Interface, 15.1
    PL/SQL, 12.3.1
    stored procedure
      location transparency with synonym, 12.2
      null values not passed, 2.5.1
      using standard Oracle PL/SQL, 12.2
  capabilities, DRDA server, native semantics, 12.6
  CCSID
    65535 as the default for all tables created, C.4.8
    CCSID (coded character set identifiers), defined, D.5
    code page mapping facility, D.4
    DRDA Server, NLS, D.1
    external mapping to supported Oracle character sets, Codepage Map Facility, 1.9.19
  changed parameters, 14.3.2
  changes in this release
    IBM DB2 Version 5.1 EBCDIC and ASCII Tables, 1.9.21
    IBM DB2/UDB supported, 1.9.20
    read-only support, 1.9.22
  CHARACTER SET
    clause, client/server configuration, D.2
    parameter description, D.1
  character sets
    and code page map facility, D.4
    ASCII, known restrictions, 1.9.21
    codepage, DRDA_DEFAULT_CCSID specifies default CCSID, C.4.8
    EBCDIC, known restrictions, 1.9.21
    supported, codepage map facility, 1.9.19
  character strings
    converting character string data types, 12.7.2
    performing character string operations, 12.7.1
  checklist
    DRDA Server configuration, 5.1
    gateway configuration, 10.1
    gateway installation, 4.3
    Oracle Net, 9.1
  CHECKSUM command
    also see Advanced Security, 1.3.3
    Oracle Net, Advanced Security Encryption, 9.5
  CICS transaction, 12.3.2
  clauses
    CHARACTER SET, client/server configuration, D.2
    CONNECT TO, 11.1.1
    GROUP BY, 12.6.3
    HAVING, 12.6.3
    ORDER BY, 12.6.3
    SQL
      DELETE, 12.7.7
      INSERT, 12.7.7
      SELECT WHERE, 12.7.7
      UPDATE, 12.7.7
    TO_DATE, 12.7.7
    USING, 11.1.1
    VALUES, 12.7.7
    WHERE
      compatible for all versions of DRDA Server, 12.6.3
      SQL limitations, Oracle ROWID column, 2.5.2
    WHERE CURRENT OF CURSOR, ROWID column, 2.5.2
  client, defined in gateway architecture, 1.5
  code page map facility
    for data translation, D.4
  code tracing, C.4.41
  codepage map facility
    configuring support for character sets, 2.5.1
    supported by gateway, 1.9.19
  coercion of data, defined, 12.6
  collection privilege - CREATE IN
    configuration worksheet, E
    DB2/OS390, 5.2.2
    DB2/VM, 5.5.2
  collection privilege - CREATETAB, DB2/OS390, 5.2.2
  column
    date columns function, 12.7.7
    Oracle ROWID, 2.5.2
    supported in a result set, 1.9.8
  commands
    AGW ADD USERID, 13.5.1.2
    AGW DELETE USERID, 13.5.1.2
    CHECKSUM
      advanced security, 1.3.3
      supported by Oracle Net, 9.5
    COPY
      known restriction for INSERT, 2.5
      SQL*Plus command, 11.8
    CREATE DATABASE LINK, 5.5.2
    EXECUTE, 1.3.9.1
    EXPLAIN PLAN, 15.4.1
    INSERT, known restriction, 2.5
  commit confirm protocol, 1.3.13
  Communication Database (CDB) tables, DDF, 5.2.5
  communications requirements, 3.2.3
  compatible SQL set operators and clauses, 12.6.3
  concatenation restrictions, 2.5.1
  concurrent connections
    APPC, 3.1.2
    TCP/IP, 3.1.2
  configuring
    additional DRDA Servers, 10.9
    AS/400 communications, 5.3.1
    AVS, 5.5.1
    binding DRDA package, 10.5
    checklist for gateway, 10.1
    checklists for DRDA Server, 5.1
    DB2/400, 5.3
    DB2/OS390, 5.2
    DB2/UDB, 5.4
    list of parameters needed to configure the gateway, E
    Oracle integrating server, 10.7
    Oracle Net, 9.4
    OS/390 (MVS) VTAM, 5.2.1
    other Oracle servers, 10.8
    SNA server, creating profiles, 6.3, 7.3
    TCP/IP
      for AS/400, 5.3.1
      for DB2/VM, 5.5.1
      for MS Windows, 8.2
      for OS/390, 5.2.1
    VM VTAM on DB2/VM, 5.5.1
    workstation for gateway, 10.4
  CONNECT authority
    binding packages on DB2/UDB, 10.4.5
    DB2/UDB, 5.4.2
    user ID mapping on DB2/VM, 13.5.1.2
  CONNECT BY not supported, known restrictions, 2.5.2
  CONNECT TO clause, 11.1.1
  connection
    definition, 6.4.3.4
    testing, 6.5, 7.5
  conversion
    data types, 12.7
    errors, C.4.8
  convert
    character string data types, 12.7.2
    character string operations, 12.7.1
    DATE, 12.7.4.2
    floating point to integer, 12.7.8
    inbound user ID, 13.5.1.2
    into most suitable data type, 12.7.10
    to the numeric data type, 12.7.8
  converter, protocol, 1.3.3
  COPY
    copying data from the DRDA server, 11.9
    copying data from the Oracle server, 11.8
    privilege
      configuration worksheet, E
      DB2/OS390, 5.2.2
      DB2/VM, 5.5.2
    SQL*Plus COPY command
      Oracle server to DRDA server, 11.8
      substituted for INSERT, 2.5
  COS function, 12.5.3
  COUNT function, 12.7.9
  CPI-C routine, 15.1.4
  CPI-C Symbolic Destination Names, 6.4.3.8
  CREATE command, supported by COPY, 11.8
  CREATE DATABASE LINK
    command, binding package on DB2/VM, 5.5.2
    statement, defining path to remote database, 11.1.1
  CREATE DATABASE statement, client/server configuration, D.2
  CREATE IN privilege
    configuration worksheet, E
    DB2/OS390, 5.2.2
    DB2/VM, 5.5.2
  CREATE PUBLIC DATABASE LINK privilege
    binding the DRDA gateway package, 10.4.4
    configuring Oracle integrating server, 10.7.1
  CREATE TABLE statement, 1.3.8
  CREATEIN privilege, DB2/UDB, 5.4.2
  CREATETAB authority, 10.4.5
  CREATETAB privilege
    DB2/OS390, 5.2.2
    DB2/UDB, 5.4.2
  creating a database link, 11.1.1
  cursor
    defining the number of, 12.10
    number of cursors, DRDA_PACKAGE_SECTIONS, C.4.24
    stability, DRDA_ISOLATION_LEVEL, C.4.16

## D

  data coercion, defined, 12.6
  data control language (DCL), 1.3.7
  data definition language (DDL), 1.3.6
  data dictionary
    support, 10.5.2
    using, 12.9.1
    views
      ALL_DB_LINKS, 11.1.4
      considerations for migration from previous releases, 14.4
      list and descriptions, A.2
      not supported for DB2/VM, A.1
      Oracle Emulation on DRDA Server, 12.9
      supported for DB2/OS390, DB2/UDB, and DB2/400 servers, A.1
      USER_DB_LINKS shows defined database links, 11.1.4
  data storage transparency (introduction), 1.3.1
  data type
    column (ALL_TAB_COLUMNS), A.2.10
    column (USER_TAB_COLUMNS), A.2.26
    conversion
      between Oracle and DRDA, 1.7
      control over, 12.7.8
      converting character string data types, 12.7.2
      gateway mapping and restrictions, 12.7
      performing character string operations, 12.7.1
    date, 2.5.1
    differences between Oracle server and DRDA databases, 12
    DRDA Server data types list, 12.7
    known restrictions, 2.5.1
    mapping, 12.7
    numeric
      zoned decimal field, 12.7.10
    Oracle data types RAW and LONG RAW, 12.7.1
    performing character string operations, 12.7.1
    restrictions, 12.7
    size and value limitations, 12.7
    supported by IBM DRDA, 12.7.4
    supported by IBM DRDA databases, 12.7.4
  data types
    DATE, as calendar date only, 12.7.4
    GRAPHIC, 12.7.3
    LONG
      converting character string data types, 12.7.2
      known restrictions, 2.5.1
    LONG RAW, translating ASCII to EBCDIC, 12.7.1
    Oracle and IBM DATA data types are mapped to each other, 12.7.4.2
    Oracle and IBM DATE, 12.7.4.2
    processing TIME data types to Oracle DATE, 12.7.4.1
    RAW
      CCSID 65535, C.4.8
      translating ASCII to EBCDIC, 12.7.1
    TIME, time of day only, 12.7.4
    TIMESTAMP, combining calendar data and time of day, 12.7.4
    VARCHAR, 12.7.2
  database
    authorities - CONNECT, BINDADD, and CREATETAB, 5.4.2
    catalogs, 12.9
    link
      behavior, 12.4
      binding DRDA gateway package, 10.4.4
      creating, 11.1.1
      defining and controlling, 13.3
      dropping links, 11.1.3
      examining, 11.1.4
      guidelines, 11.1.2
      limits, 11.1.5
      processing, 11.1
      public, 10.7.1
      suffix, 12.1
      to identify the gateway, 1.7
    native tool, 10.5.2
    triggers, 1.3.2
  date
    2 or 4 digits, 12.7.5
    arithmetic, known restrictions, 2.5.1
    columns function, 12.7.7
    data types and DRDA server restriction, 2.5.1
    data types supported by IBM DRDA, 12.7.4
    date handling has two categories, 12.7.5
    gateway local date exit for DB2 ISO format, 12.7.6
    HS_NLS_DATE_FORMAT
      parameter, date handling, 12.7.5
      patterns, 12.7.6
    operations, 12.7.4
    statements, SELECT, INSERT, UPDATE, DELETE, 12.7.5
    TO_DATE function
      date handling, 12.7.5
      preprocessed in SQL, 12.7.7
  DATE data type
    implementation, 12.7.4
    processing DATE data, 12.7.4.2
  DB_DOMAIN parameter, 2.5.1
  DB2
    02pcg.sql granting authority, 10.5.2.5
    alias objects, known restrictions, 2.5
    aliases, not compatible with DRDA_DESCRIBE_TABLE, C.4.9
    CICS, IMS, 12.3.2
    data access, 1.3.9.1
    Distributed Data Facility (DDF), 5.2.5
    DRDA_DESCRIBE_TABLE compatibility, C.4.9
    IBM DB2 version 5.1 ASCII Tables, 1.9.21
    native SQL, 1.3.8
    native stored procedures, 1.3.9.2
    procedural feature considerations, 12.3.2
    SPUFI utility, 5.2.5
    SQL statements, 12.8.2
    statements, CREATE TABLE, 1.3.8
    stored procedures, considerations for use, 12.3.2
    with OS/390, 5.2
  DB2/400
    catalog view, 12.9.1
    configuring the DRDA Server, 5.3
    data dictionary views supported by gateway, A.1
    defining user ID, 5.3.2
    DRDA_DEFAULT_CCSID, C.4.8
    DRDA_ISOLATION_LEVEL, C.4.16
    DRDA_OPTIMIZE_QUERY, C.4.19
    DRDA_PACKAGE_COLLID, C.4.20
    userid mapping, different capability, 13.5.1.3
  DB2INS sample DB2 stored procedure, G.1
  DB2/OS390
    catalog view, 12.9.1
    configuring, 5.2
    data dictionary views supported by gateway, A.1
    DRDA_ISOLATION_LEVEL, C.4.16
    DRDA_OPTIMIZE_QUERY, C.4.19
    userid mapping, 13.5.1.1
    V6, V7 and V8 stored procedures supported, 1.9.18
    with SPUFI, 10.5.2
  DB2/UDB
    catalog view, 12.9.1
    configuring, 5.4
    configuring the DRDA Server, 5.4
    data dictionary views not supported, A.1
    DRDA_ISOLATION_LEVEL, C.4.16
    DRDA_OPTIMIZE_QUERY, C.4.19
    grant authority, 10.5.2.5
    known restrictions, 2.5.1
    ORACLE2PC table, binding packages, 10.5.1.2
    supported, changes in this release, 1.9.20
    userid mapping, 13.5.1.4
  DB2/VM
    catalog view, 12.9.1
    configuring, 5.5
    data dictionary views not supported, A.1
    database and SQL functions, 12.5.8
    DRDA_ISOLATION_LEVEL, C.4.16
    DRDA_OPTIMIZE_QUERY, C.4.19
    DRDA_PACKAGE_OWNER, C.4.23
    instance, DRDA location name, 5.5.4
    server machine, 13.5.1.2
    userid mapping, 13.5.1.2
  DBMS_HS_PASSTHROUGH.EXECUTE_IMMEDIATE function
    limited to nonqueries, 12.8
    native SQL passthrough, 12.8
    syntax, 12.8.2
  DD basic tables, known restrictions, 2.5.1
  DDF
    subsystem, 5.2.1
  DDL statement
    native SQL passthrough, 12.8
    number of rows affected, 12.8.2
  debugging
    error codes, 15.1.3
    SQL tracing, 15.4
    your application, 11.10
  de-installing the gateway, 4.7.1
  DELETE
    known restrictions, 2.5.2
    operation, 12.1
    SQL clause, 12.7.7
    statement
      dates, 12.7.5
      native SQL passthrough, 12.8
      transaction semantics, 1.7.1
    with read-only gateway, 11.6
  Dependent LU, 6.3.1, 7.3.1
  DESCRIBE
    character string operations, 12.7.1
  diagnostic parameter, C.4.39
  dictionary
    mapping, 1.3.4
    tables, 12.9
  DICTIONARY view, A.2.15
  disk space requirements, 3.1.4
  distributed
    applications, support for, 1.9.15
    database, 9.3.2
    distributed query optimizer (DQO), better performance of distributed queries, 11.5
    operations, DB2, 5.2.5
    processing, 9.3.1
    queries
      example of, 11.5.1
      two-phase commit, 11.5.2
    transaction, DRDA_RECOVERY_USERID, C.4.27
  distributed query optimizer (DQO), DRDA-specific parameters, C.4.19
  double-byte support, D.5
  DQO
    also see distributed query optimizer, 11.5
    DRDA-specific parameters, C.4.19
  drc error code, 15.1.3
  DRDA
    catalog, 12.9.2
    database requirements, 3.2.2
    defining number of cursors, 12.10
    location name
      for DB2/UDB instance, 5.4.4
      for DB2/VM instance, 5.5.4
    session security options, 13.5.1.1
  DRDA Application Server Function, 1.9.12
  DRDA Server
    accessing, 10.9
    capabilities, native semantics, 12.6
    CCSID
      character set to store data in DRDA database, D.1
      gateway code page map facility, D.4
      parameters needed for NLS, D.1
    character sets, known restrictions, 2.5.1
    configuring
      DB2/400, 5.3
      DB2/OS390, 5.2
      DB2/UDB, 5.4
      DB2/VM, 5.5
    considerations for binding packages, 14.4
    database link behavior, 12.4
    functions, native semantics, 12.6
    gateway architecture definition, 1.5
    Hostname or IP Address (configuring TCP/IP, worksheet), E
    port number (TCP/IP), 8.1.1
    Service Port Number (configuring TCP/IP, worksheet), E
    stored procedures, native to DRDA server, 12.3
  DRDA_CAPABILITY parameter, 12.6
  DRDA_CMSRC_CM_IMMEDIATE parameter, description, C.4.7
  DRDA_CODEPAGE_MAP parameter, D.4
  DRDA_COMM_BUFLEN parameter, description, C.4.4
  DRDA_CONNECT_PARM
    (SNA format) parameter, description, C.4.5
    (TCP/IP format) parameter, description, C.4.6
    configuring IBM Communication Server, 7.4.1.2
    configuring Microsoft SNA server or host server, 6.4.3.8
    parameter
      communication errors, 15.1.4
      configuring the gateway for TCP/IP, 8.2
  DRDA_DEFAULT_CCSID parameter, description, C.4.8
  DRDA_DESCRIBE_TABLE parameter
    description, C.4.9
    known restrictions, 2.5
  DRDA_DESCRIBE_TABLE=FALSE initialization parameter, 2.5
  DRDA_DISABLE_CALL parameter
    binding the DRDA gateway package, 10.5.1.1
    description, C.4.10
  DRDA_FLUSH_CACHE parameter, description, C.4.11
  DRDA_GRAPHIC_LIT_CHECK parameter, description, C.4.13
  DRDA_GRAPHIC_PAD_SIZE parameter, description, C.4.12
  DRDA_GRAPHIC_TO_MBCS parameter, description, C.4.14
  DRDA_ISOLATION_LEVEL parameter, description, C.4.16
  DRDA_LOCAL_NODE_NAME parameter, description, C.4.17
  DRDA_MBCS_TO_GRAPHIC parameter, description, C.4.18
  DRDA_OPTIMIZE_QUERY parameter
    description, C.4.19
    DQO capability turned ON and OFF, 11.5
  DRDA_PACKAGE_COLLID parameter
    description, C.4.20
    errors detected by server database, 15.1.5
  DRDA_PACKAGE_CONSTOKEN parameter, description, C.4.21
  DRDA_PACKAGE_NAME parameter
    description, C.4.22
    detecting errors, 15.1.5
    value must be unique, 10.5.1.1
  DRDA_PACKAGE_OWNER parameter, description, C.4.23
  DRDA_PACKAGE_SECTIONS parameter
    description, C.4.24
    number of open cursors at IBM database, 12.10
  DRDA_READ_ONLY parameter
    description, C.4.25
    read-only gateway, 11.6
  DRDA_RECOVER_USERID parameter
    DB2/400, 5.3.3
    DB2/OS390, 5.2.3
  DRDA_RECOVERY_PASSWORD parameter
    DB2/OS390, 5.2.3, 5.3.3
    DB2/UDB, 5.4.3
    DB2/VM, 5.5.3
    description, C.4.26
  DRDA_RECOVERY_USERID parameter
    DB2/400, 5.3.3
    DB2/UDB, 5.4.3
    DB2/VM, 5.5.3
    description, C.4.27
  DRDA_REMOTE_DB_NAME parameter, description, C.4.28
  DRDA_SECURITY_TYPE parameter, description, C.4.29
  DROP DATABASE LINK statement, 11.1.3
  dropold.sql script, 10.5.2.2
  DSPRDBDIRE command, 5.3.4
  dynamic dictionary mapping, 1.3.4

## E

  EBCDIC
    character set support, D.3.2.1
    code page, D.3
    DRDA server CCSID, D.7
    sort order, 12.6.2
    tables, known restrictions, 1.9.21
    translated to ASCII, 12.7.1
  EMP
    creating system-wide synonym for EMP file, 11.4
    table, 11.8
  empproc
    stored procedure, 12.3
  encryption
    export encryption algorithms, 9.5
    types for Advanced Security, 9.6
  environment
    distributed, 12.2
    heterogeneous, replicating in, 11.7
    variable, NLS_LANG, D.2
  environmental variable
    NLS_LANG, D.1
    ORA_NLS33, D.1
  errd
    error array returned from DRDA server database, 15.1.5
    example of translated, mapped error, 15.2
    example, retrieving data, 11.2.3
  errmc
    (error tokens), 15.1.5
    communication errors, 15.1.4
    errmc field lists any error tokens, 15.1.3
    example of translated, mapped error, 15.2
    example, retrieving data, 11.2.3
  error
    12660 (test error for Advanced Security), 9.6
    basic description, 15.1
    change
      ORA-09100 to ORA-28500, 15.1.3
      ORA-09101 to ORA-28501, 15.1.3
    codes
      drc, 15.1.3
      grc, 15.1.3
    communication, 15.1.4
    condition, 15.1
    conversion, C.4.8
    date, D.3.2.3
    detected
      by gateway, 15.1.2
      by integrating Oracle instance, 15.1.1
      by server database, 15.1.5
      in DRDA software, 15.1.3
    drc= field
      -300xx, 15.3
      -7xx, 15.3
    HGO-00706, 15.1.2
    host database, 15.3
    interpreting error messages, 15.1
    mapped sqlstate, 15.2
    messages & codes, main chapter, 15
    messages, Oracle LONG data type larger than 32740 bytes, 12.7.2
    number, return code, 15.1
    ORA-00001, index constraint violated, 15.2
    ORA-00942
      object does not exist, 15.2
      object name too long, 15.2
    ORA-01017, logon denied, 15.2
    ORA-01031, insufficient privileges, 15.2
    ORA-01460, invalid CCSID, 15.2
    ORA-01476, divide by zero, 15.2
    ORA-02019, undefined database link name is specified, 15.1.1
    ORA-28500
      was ORA-09100, 15.1.3
      detected by server database, 15.1.5
      example, collection ID or package name not recognized, 15.1.5
    ORA-28501
      was ORA-09101, 15.1.4
      communication error, 15.1.4
      Side Information Profile not defined, 15.1.4
    ORA-28527, conversion errors, C.4.8
    ORA-9100 to ORA-9199, reserved for generic gateway layer, 15.1.1
    Oracle error code for mapped errors, 15.2
    server database, 15.1.5
    specific error codes, 15.3
    tokens listed by errmc for errors
      detected by DRDA gateway, 15.1.3
      detected by server database, 15.1.5
    translation, 12.7.1
    while binding the gateway package, 10.4.4
    with Native Semantics, 12.6
  errp
    example, retrieving data, 11.2.3, 15.1.3, 15.1.5, 15.2
  EXCEPT set operator, 12.6.3
  execute authority
    DB2/400, 13.5.1.3
    DB2/UDB, 13.5.1.4
    DB2/VM, 13.5.1.2
    on the gateway DRDA package, 13.5.1.2
  EXECUTE command, 1.3.9.1
  EXECUTE privilege
    configuration worksheet, E
    DB2/OS390, 5.2.2
    DB2/UDB, 5.4.2
    DB2/VM, 5.5.2
  exits, gateway local date, 12.7.6
  EXPLAIN PLAN command, 15.4.1
  EXPLAIN_PLAN table, features of the gateway, 1.9.9
  export encryption algorithms, 9.5

## F

  FDS_CLASS parameter, description, C.4.30
  FDS_CLASS_VERSION parameter, description, C.4.31
  FDS_INSTANCE parameter, description, C.4.32
  features of the gateway
    main topic, 1.9
    application development and end-user tools, 1.9.16
    application portability, 1.9.13
    columns supported in a result set, 1.9.8
    distributed applications supported, 1.9.15
    EXPLAIN_PLAN improvement, 1.9.9
    fetch reblocking, 1.9.3
    heterogeneous database integration, 1.9.10
    heterogeneous services architecture, 1.9.1
    large base of data access, 1.9.12
    minimum impact on existing systems, 1.9.11
    Native Semantics, 1.9.7
    Oracle Database 10g passthrough supported, 1.9.4
    Oracle snapshot, 11.7.2
    performance enhancements, 1.9.2
    remote data access, 1.9.14
    retrieving result sets through passthrough, 1.9.5
    support for TCP/IP, 1.9.6
  fetch array size, with HS_FDS_FETCH_ROWS, C.4.33
  fetch reblocking
    features of the gateway, 1.9.3
    supported with HS_RPC_RETCH_REBLOCKING, 12.1.1
  fetched date, ORA_MAX_DATE parameter, description, C.4.37
  fields
    errmc, lists any error tokens, 15.1.3
    errp, indicates program that detected error, 15.1.3
  files
    initsid.ora
      invalid ORA_MAX_DATE specified, 15.3
      parameter not recognized, 15.1.5
    installation log file, verifying successful installation, 4.6.5
    listener.ora
      configure additional instance, 10.9
      IPC key defined in, 9.4.2
    member name, 11.3
    sample
      gateway initialization, tnsnames.ora, listener.ora, B
      listener.ora, B.3
    tnsnames.ora
      configuring additional DRDA Server instance, 10.9
      modifying the file, 9.4.2
    VSAM, 12.3.2
  FOR BIT DATA
    DRDA_DEFAULT_CCSID, C.4.8
    indicates RAW or LONG RAW, 12.7.1
    option, 12.7.1
  free session, DRDA_CMSRC_CM_IMMEDIATE, C.4.7
  functions
    COS, 12.5.3
    COUNT, 12.7.9
    DBMS_HS_PASSTHROUGH.EXECUTE_IMMEDIATE, 12.8.2
    DRDA server, native semantics, 12.6
    GROUPBY, 12.6.2
    HAVING, 12.6.2
    ROWID, with UPDATE or DELETE, 2.5.2
    SQL, SUBSTR, 12.6
    SUBSTR
      known restrictions, 2.5.1
    TO_DATE
      entering twenty-first century dates, 12.7.5
      Oracle function, preprocessed in SQL, 12.7.7
      processing DATE data, 12.7.4.2
    WHERE, 12.6.2

## G

  g4ddtab.sql script, 10.5.2.3
  g4ddview.sql script, 10.5.2.3
  gateway
    access, 10.8
    advantages
      migration and coexistence, 1.3.15
      security, 1.3.16
      server technology and tools, 1.3.11
      site autonomy, 1.3.14
      two-phase commit and multi-site transactions, 1.3.13
      use of SQL, 1.2.1
    application tools, 1.9.16
    architecture, 1.5
    benefits of integration with Oracle Database 10g server, 1.3.3
    configuration, 10.3
    definition of terms, 1.4
    de-installing, 4.7.1
    features, main topic, 1.9
    gateway and Oracle integrating server not on same host, 1.5
    installing, 4.6
    interface function, 1.7
    local date exit, 12.7.6
    logging, LOG_DESTINATION, C.4.36
    migration problems, backout considerations, 14.2
    parameter, 5.5.4
    performance, 12.6
    performance enhancements, 1.9.2
    service name entries in the tnsnames.ora, 14.5
    SQL differences, 1.7.1
    stored procedures (Oracle and non-Oracle), 1.3.9
    supported languages
      CCSID, D.1
      codepage map facility, D.4
    tracing
      LOG_DESTINATION, C.4.36
      SQL statements, 11.10
  Gateway Initialization File
    parameter
      list, C.4
      new since V4 gateway, 14.3.1.1
      reported errors, 10.4.4
    sample, B.1
  Gateway Initialization Parameter, DRDA_READ_ONLY, 11.6
  Gateway System Identifier (SID), defined, 10.2
  GCS virtual machine, 13.5.1.2
  GLOBAL_NAMES
    known restrictions, 2.5.1
  GRANT
    DB2/VM security, 13.5.1.2
    statement, synonyms and views, 10.7.2
  granting authority to a package for DB2, 10.5.2.5
  GRAPHIC data type, 12.7.3
  graphic string operations, unsupported, 12.7.3
  grc error code, 15.1.3
  GROUP BY clause, 12.6.3
  GROUPBY function, 12.6.2
  GTW$_BIND_PKG
    configuring the host, 10.4.4
    gateway package considerations, 10.5

## H

  hardware requirements, memory, 3.1.2
  HAVING
    clause compatible for all versions of DRDA Server, 12.6.3
    SQL Functions That Can Be Disabled, 12.6.2
  heterogeneous database integration, 1.9.10
  Heterogeneous Services (HS)
    see also HS, 1.2
    component of the Oracle Database 10g server, 1.2
    parameter syntax and usage, C.3
  HGO-00706 error, 15.1.2
  host
    architecture, 1.5
    components when installed on gateway, 1.6
    creating an independent process, 1.6
    database error, 15.3
    networking needs, 3.2.5
    relationship to gateway and Oracle server, 1.5
    variable
      converting character string data types, 12.7.2
      moving data between applications and the database, 12.7
  HS (Heterogeneous Services)
    architecture features, 1.9.1
    Oracle Net considerations, 14.5
  HS= (TNSNAMES parameter for Oracle Net)
    gateway migration problems, 14.2
    modify tnsnames.ora file, 9.4.2
  HS_DB_DOMAIN parameter, 2.5.1
  HS_DB_NAME parameter, 2.5.1
  HS_FDS_FETCH_ROWS parameter, description, C.4.33
  HS_LANGUAGE parameter, description, C.4.34
  HS_NLS_DATE_FORMAT
    NLS parameters for initsid.ora file, D.3.2.3
    parameter, 12.7.5
    support, 12.7.6
  HS_NLS_DATE_LANGUAGE, D.3.2.4
  HS_NLS_NCHAR
    parameter description, C.4.35
    parameters in the Gateway Initialization File, D.3.2.2
  HS_RPC_FETCH_REBLOCKING parameter
    fetch reblocking described, 12.1.1
    gateway features, 1.9.3
  HS_RPC_FETCH_SIZE parameter
    fetch reblocking described, 12.1.1
    gateway features, 1.9.3

## I

  IBM Communication Server
    definitions, 7.4.1
    server selection, 7.4.1.1
  implementation, gateway components, 1.6
  implicit data conversion, 12.6
  implicit protocol conversion, 1.3.3
  IMS transaction, 12.3.2
  IN and OUT columns, multi-byte support, D.5
  inbound connections
    processing, 13.5
  Independent LU
    configuring IBM Communication Server, 7.3.1
    configuring Microsoft SNA Server, 6.3.1
  initdrdahoa1.ora
    sample Gateway Initialization File, B.1
  initialization parameters
    new since V4 gateway, 14.3.1.1
  initsid.gtw file
    sample, 10.4.1
  initsid.gtwboot
    file, migrating, 14.1.2
    parameters moved to initsid.ora, 10.4
  initsid.ora file
    containing initsid.gwtboot parameters, 10.4
    invalid ORA_MAX_DATE specified, 15.3
    migrating, 14.1.2
    NLS parameters, D.3.2
    parameter not recognized, 15.1.5
    parameters have changed format, 14.1.3
    sample, 10.4.1
    simplified syntax, see Appendix C, 10.4
    tailoring, 10.4.2.1
  input bind variables, 12.7.4.2
  INSERT
    command
      known restriction, 2.5
      supported by COPY, 11.8
    operation, 12.1
    Oracle SQL command, known restrictions, 2.5
    SQL clause, 12.7.7
    statement
      dates, 12.7.5
      native SQL passthrough, 12.8
      transaction semantics, 1.7.1
    with read-only gateway, 11.6
  installation
    checklists
      configuring the gateway, 10.1
      DRDA Server, 5.1
      gateway, 4.3
      Oracle Net, 9.1
    configuring multiple DRDA Servers
      details, 10.9
      overview, 4.4
    configuring multiple integrating servers
      details, 10.8
      overview, 4.4
    from CD, 4.6
    log file, INSTALL.LOG, 4.6.5
    overview, 4.4
  INSTALL.LOG, 4.6.5
  internal tracing, C.4.40
  Internet and intranet support, 1.3.3
  INTERSECT, set operators, 12.6.3
  IPC adapter, B.3
  ISO standard
    SQL, 1.3.5
  isolation level, DRDA_ISOLATION_LEVEL, C.4.16

## J

  JOIN capability, 1.3.2
  JOIN SQL statement, 12.1

## K

  keywords
    LISTENER, sample listener.ora file, B.3
  known restrictions
    main topic, 2.5
    accessing DB2 alias objects, 2.5
    AVS mapping user IDs, 2.5.1
    bind variables become SQL parameter markers, 2.5.2
    binding the DRDA gateway package on DB2/UDB, 2.5.1
    CONNECT BY not supported, 2.5.2
    data type limitations, 2.5.1
    date arithmetic, 2.5.1
    DD basic tables and views, 2.5.1
    dictionary views not provided for DB2/VM, 2.5.1
    DRDA server character sets, 2.5.1
    GLOBAL_NAMES parameter, 2.5.1
    LONG data type in SQL*Plus, 2.5.1
    null values and stored procedures, 2.5.1
    Oracle ROWID column, 2.5.2
    row length, 2.5.1
    row length limitation, 2.5.1
    SAVEPOINT, 2.5.1
    single gateway instances per DRDA network interface, 2.5.1
    string concatenation, 2.5.1
    SUBSTR function post-processed, 2.5.1

## L

  LANGUAGE parameter, D.3.2.1
  languages
    SQL*Plus, 1.3.12
    tools supported through the gateway, 1.3.10
  link
    also see Database Link, 12.4
    service definition, 6.4.3.3
  linkage conventions
    SIMPLE with nulls, 12.3.2
  listener
    sample Oracle Net listener.ora file, B.3
  LISTENER keyword, sample listener.ora file, B.3
  listener.ora file
    configuring additional DRDA Server instances, 10.9
    IPC key defined, 9.4.2
    sample, B.3
  literal
    character literals, 12.7.4.1
    date, 12.7.4.2
    specific data type, 12.7
    TO_DATE, 12.7.7
  Local LU definition, 6.4.3.5
  location transparency (introduction), 1.3.1
  log file, installation, verifying success, 4.6.5
  LOG_DESTINATION parameter
    description, C.4.36
    used with ORACLE_DRDA_TRACE, C.4.40
  logging, LOG_DESTINATION, C.4.36
  LONG columns, known restrictions, 2.5.1
  LONG data type
    converting character string data types, 12.7.2
    known restrictions, 2.5.1
  LONG RAW datat ype, translating ASCII to EBCDIC, 12.7.1
  LUs
    dependent, 7.3.1
    independent, 7.3.1
    independent and dependent, 6.3.1
    local definition, alias, network name, 6.4.3.5
    remote definition, 6.4.3.7

## M

  mapped sqlstate errors, 15.2
  mapping user IDs, known restrictions, 2.5.1
  memory, hardware requirements, 3.1.2
  Microsoft Windows Sockets, network attachment, 3.1.3
  migration
    defined, 14.1
    migrating the gateway instance, 14.4
    obsolete parameters, 14.3.4
    problems, backout considerations, 14.2
  MINUS
    set operator, 12.6.3
  Mobile Agents, 1.3.3
  Mode definition, 6.4.3.6
  multi-byte support, D.5

## N

  National Language Support
    initsid.ora parameters, D.3.2
    overview, D
  Native Semantics
    main topic, 12.6
    gateway features, 1.9.7
    parameters, 12.6.3
    with SUBSTR function, 2.5.1
  native SQL passthrough, 12.8
  network
    configuration tool, 8.2
    Oracle Net configuration, 9.4
    requirements, 3.1.3
    transparency (introduction), 1.3.1
  NLS
    also see National Language Support, D
    DRDA server character sets
      codepage map facility, D.4
      parameters needed for NLS processing, D.1
  NLS parameters, configuration on client and Oracle servers, D.2
  NLS_LANG
    environment variable
      client-server configuration, D.2
      parameters needed for NLS processing, D.1
    server-side parameter, D.1
  non-character binary data, 12.7.1
  null
    rows, mapping the COUNT function, 12.7.9
    values
      known restrictions, 2.5.1
      mapping the COUNT function, 12.7.9
  number of cursors, DRDA_PACKAGE_SECTIONS, C.4.24
  numbers, concatenation restrictions, 2.5.1
  numeric data type
    conversion, destination column, 12.7.8
    zoned decimal operations, 12.7.10

## O

  o2pc.sql
    binding the DRDA gateway package, 10.5.2.6
    two-phase commit processing, 11.5.2
  obsolete parameters since V4 gateway, 14.3.4
  open cursors, at the IBM database, 12.10
  OPEN_LINKS parameter, 11.1.5
  operating system requirements, 3.2.1
  operating system transparency (introduction), 1.3.1
  operations, SELECT, INSERT, UPDATE, DELETE, 12.1
  operators
    UNION, 12.6.3
    UNION ALL, 12.6.3
  option
    binding packages, 10.4.5
    data dictionary views, 12.9
    date format string, 12.7.5
    DRDA session security, 13.5.1.1
    FOR BIT DATA, 12.7.1
    Oracle server, 1.5
    read-only
      gateway configuration, 1.3.13
      no updates permited by gateway, 11.6
    replicating, 11.7
    security conduct, 13.5
    service port number, DRDA_CONNECT_PARM, C.4.6
    SNA security
      configuring IBM Communication Server, 7.7
      configuring Microsoft SNA Server or Host Integration Server, 6.7
    SQL functions that can be disabled, 12.6.2
    SQL functions that can be enabled, 12.6.1
    SQL*Plus COPY command, 11.8
  ora
    listener.ora file, 10.9
    tnsnames.ora file, 9.4.2
  ORA_MAX_DATE parameter, description, C.4.37
  ORA_NLS33 parameter
    description (default value), C.4.38
    needed in system environment, D.1
  ORA-00001 error, index constraint violated, 15.2
  ORA-00942 error
    object does not exist, 15.2
    object name too long, 15.2
  ORA-01017 error, logon denied, 15.2
  ORA-01031 error, insufficient privileges, 15.2
  ORA-01460 error, invalid CCSID, 15.2
  ORA-01476 error, divide by zero, 15.2
  ORA-02019 error, undefined database link name is specified, 15.1.1
  ORA1 Oracle instance, 12.2
  ORA-28500 error
    was ORA-09100, 15.1.3
    example, collection ID or package name not recognized, 15.1.5
  ORA-28501 error
    was ORA-09101, 15.1.3
    communication error, 15.1.4
    Side Information Profile not defined, 15.1.4
  ORA-28527, conversion errors, C.4.8
  ORA-9100 error, 15.1.1
  ORA-9199 error, 15.1.1
  Oracle
    error code, mapped errors, 15.2
    error number or return code, 15.1
    products compatibility, 1.8
    RAW data type, C.4.8
    snapshots, 11.7.2
    stored procedure, defined, 12.2
  Oracle Database 10g server
    introduction, 1.2
    relationship to host, 1.5
    services
      list, 1.3.2
      database triggers, 1.3.2
      distributed capabilities, 1.3.2
      distributed query optimization, 1.3.2
      SQL, 1.3.2
      stored procedures, 1.3.2
      two-phase commit protection, 1.3.2
  Oracle integrating server
    architecture, 1.5
    configuration, 10.7
    defined in gateway architecture, 1.5
    gateway and Oracle integrating server not on same host, 1.5
    requirements, 3.2.4
  Oracle Net
    and application development, 1.9.16
    and remote data access, 1.9.14
    and server coexistence, 1.5
    API, 9.3
    compatibility with SQL*Net, 9.2
    configuring, 9.4
    distributed
      database, 9.3.2
      processing, 9.3.1
    editing to set up security test, 9.6.1
    gateway and Oracle integrating server not on same host, 1.5
    gateway migration problems, 14.2
    Heterogeneous Services (HS) facility, 9.2
    introduction, 9.2
    migration considerations, 14.5
    operating system authentication, 13.2
    overview, 9.3
    purpose, 1.6
    requirements, 3.2.5
    sample files, B
    sample listener.ora file, B.3
    support (introduction), 1.3.11
    support for CHECKSUM and encryption, 9.5
    terminology, 9.3.3
  Oracle ROWID column, 2.5.2
  Oracle ROWID function, with UPDATE or DELETE, 2.5.2
  ORACLE_DRDA_TCTL parameter, description, C.4.39
  ORACLE_DRDA_TRACE parameter, description, C.4.40
  ORACLE_HOME, preinstallation and caution notice, 4.5
  ORACLE2PC table
    before binding gateway package, 10.5.1.2
    binding packages on DB2/UDB, 10.4.5
    DB2/400, 5.3.2
    DB2/OS390, 5.2.2
    DB2/UDB, 5.4.2
    DB2/UDB, granting authority to package, 10.5.2.5
    DB2/VM, 5.5.2
    distributed DRDA transactions, 11.5.3
    DRDA_PACKAGE_OWNER description, C.4.23
  ORADRDA.ORACLE2PC table, two-phase commit, 11.5.2
  ORAIND sample DB2 stored procedure, G.2
  oraproc1, stored procedure, 12.2
  oraproc2, stored procedure, 12.2
  ORARECOV user ID
    DB2/400, 5.3.3
    DB2/OS390, 5.2.3
    DB2/UDB, 5.4.3
    DB2/VM, 5.5.3
    DRDA_RECOVERY_USERID description, C.4.27
  ORA2 Oracle instance, 12.2
  ORDER BY clause, 12.6.3
  OS/390 (MVS) VTAM, configuring, 5.2.1

## P

  package
    collection id, DRDA_PACKAGE_COLLID, C.4.20
    consistency token, DRDA_PACKAGE_CONSTOKEN, C.4.21
    privileges - BIND and EXECUTE, DB2/UDB, 5.4.2
    privileges - BIND, COPY, and EXECUTE
      configuration worksheet, E
      DB2/OS390, 5.2.2
      DB2/VM, 5.5.2
  packed decimal, 12.7.10
  parameter
    changed, 14.3.2
    checking settings, 10.5.1.1
    diagnostic, C.4.39
    gateway, 5.5.4
    list of parameters needed to configure the gateway, E
    Native Semantics, 12.6.3
    new since V4 gateway, 14.3.1.1
    obsolete since V4 gateway, 14.3.4
    parameter syntax and usage, C.3
    renamed since V4 gateway, 14.3.3
  parameters
    DB_DOMAIN, 2.5.1
    DRDA_CAPABILITY, 12.6
    DRDA_CODEPAGE_MAP
      described, C.4.3
      mapping IBM CCSID, D.4
    DRDA_CONNECT_PARM
      configuring IBM Communication Server, 7.4.1.2
      configuring Microsoft SNA server or host server, 6.4.3.8
      configuring the gateway for TCP/IP, 8.2
    DRDA_DESCRIBE_TABLE, known restrictions, 2.5
    DRDA_DISABLE_CALL, 10.5.1.1
    DRDA_PACKAGE_NAME, 10.5.1.1
    DRDA_PACKAGE_SECTIONS, open cursors, 12.10
    DRDA_READ_ONLY, read-only gateway, 11.6
    DRDA_RECOVERY_PASSWORD
      DB2/400, 5.3.3
      DB2/OS390, 5.2.3
      DB2/UDB, 5.4.3
      DB2/VM, 5.5.3
    DRDA_RECOVERY_USERID
      DB2/400, 5.3.3
      DB2/OS390, 5.2.3
      DB2/UDB, 5.4.3
      DB2/VM, 5.5.3
    FDS_CLASS, description, C.4.30
    FDS_CLASS_VERSION, description, C.4.31
    FDS_INSTANCE, description, C.4.32
    Gateway Initialization File
      DRDA_CACHE_TABLE_DESC, C.4.1
      DRDA_CAPABILITY, C.4.2
      DRDA_CMSRC_CM_IMMEDIATE, C.4.7
      DRDA_CODEPAGE_MAP, C.4.3
      DRDA_COMM_BUFLEN, C.4.4
      DRDA_CONNECT_PARM, 8.2, 15.1.4
      DRDA_CONNECT_PARM (SNA format), C.4.5
      DRDA_CONNECT_PARM (TCP/IP format), C.4.6
      DRDA_DEFAULT_CCSID, C.4.8
      DRDA_DESCRIBE_TABLE, C.4.9
      DRDA_DISABLE_CALL, C.4.10
      DRDA_FLUSH_CACHE, C.4.11
      DRDA_GRAPHIC_LIT_CHECK, C.4.13
      DRDA_GRAPHIC_PAD_SIZE, C.4.12
      DRDA_GRAPHIC_TO_MBCS, C.4.14
      DRDA_ISOLATION_LEVEL, C.4.16
      DRDA_LOCAL_NODE_NAME, C.4.17
      DRDA_MBCS_TO_GRAPHIC, C.4.18
      DRDA_OPTIMIZE_QUERY, 11.5, C.4.19
      DRDA_PACKAGE_COLLID, 15.1.5, C.4.20
      DRDA_PACKAGE_CONSTOKEN, C.4.21
      DRDA_PACKAGE_NAME, 15.1.5, C.4.22
      DRDA_PACKAGE_OWNER, C.4.23
      DRDA_PACKAGE_SECTIONS, C.4.24
      DRDA_READ_ONLY, C.4.25
      DRDA_RECOVERY_PASSWORD, C.4.26
      DRDA_RECOVERY_USERID, C.4.27
      DRDA_REMOTE_DB_NAME, C.4.28
      DRDA_SECURITY_TYPE, C.4.29
      HS_FDS_FETCH_ROWS, C.4.33
      HS_LANGUAGE, C.4.34
      HS_NLS_NCHAR, C.4.35
      LOG_DESTINATION, C.4.36
      ORA_MAX_DATE, C.4.37
      ORA_NLS33, C.4.38
      ORACLE_DRDA_TCTL, C.4.39, C.4.39
      ORACLE_DRDA_TRACE, C.4.40
      TRACE_LEVEL, C.4.41
    HS_DB_DOMAIN, 2.5.1
    HS_DB_NAME, 2.5.1
    HS_NLS_DATE_FORMAT, 12.7.5
    HS_RPC_FETCH_REBLOCKING
      gateway features, 1.9.3
      gateway support for fetch reblocking, 12.1.1
    HS_RPC_FETCH_SIZE
      gateway features, 1.9.3
      gateway support for fetch reblocking, 12.1.1
    LOG_DESTINATION, description, C.4.40
    NLS_DATE_FORMAT, 12.7.5
    OPEN_LINKS, 11.1.5
  passthrough
    DBMS_HS_PASSTHROUGH.EXECUTE_IMMEDIATE
      gateway features, 1.9.4
    DBMS_HS_PASSTHROUGH.EXECUTE_IMMEDIATE syntax
      using the passthrough function, 12.8.2
    example, 12.8.3.1
    gateway feature, 1.3.8
    native SQL through the gateway, 12.8
    result sets example, 12.8.3.1
    result sets from queries, 12.8
    retrieving result sets, 12.8.3
    SQL feature, 12.8
  performance enhancements with fetch reblocking, 12.1.1
  PL/SQL
    call, 12.3.1
    records, 12.3.2
    routine, 1.3.9.1
    running stored procedures, 12.3
    standard Oracle, 1.3.9.2
    stored procedure, 12.2
  port number
    446 as default for DRDA services (TCP/IP), 8.1.1
    5000 as default for DRDA services (TCP/IP), 8.1.1
    for DRDA Server (TCP/IP), 8.1.1
    Primary
      DB2/400, 5.3.1
      DB2/OS390, 5.2.1
    Recovery
      DB2/400, 5.3.1
      DB2/OS390, 5.2.1
  post processing
    defined, 12.5.3
    native semantics, 12.6
    post-processed SQL functions, overview, 12.5.3
    SQL tracing, 15.4.1
  PREPARE TRANSACTION statement, two-phase commit, 11.5.2
  primary port number
    DB2/400, 5.3.1
    DB2/OS390, 5.2.1
  privileges
    BIND
      configuration worksheet, E
      DB2/OS390, 5.2.2
      DB2/UDB, 5.4.2
      DB2/VM, 5.5.2
    BINDADD
      configuration worksheet, E
      DB2/OS390, 5.2.2
      DB2/UDB, 5.4.2
      DB2/VM, 5.5.2
    BINDAGENT
      configuration worksheet, E
      DB2/OS390, 5.2.2
      DB2/VM, 5.5.2
    CONNECT
      DB2/UDB, 5.4.2
    COPY
      configuration worksheet, E
      DB2/OS390, 5.2.2
      DB2/VM, 5.5.2
    CREATE IN
      configuration worksheet, E
      DB2/OS390, 5.2.2
      DB2/VM, 5.5.2
    CREATE PUBLIC DATABASE LINK
      binding the DRDA gateway package, 10.4.4
      configuring the Oracle integrating server, 10.7.1
    CREATEIN
      DB2/UDB, 5.4.2
    CREATETAB
      DB2/OS390, 5.2.2
      DB2/UDB, 5.4.2
    data dictionary limitations, 12.9
    EXECUTE
      configuration worksheet, E
      DB2/OS390, 5.2.2
      DB2/UDB, 5.4.2
      DB2/VM, 5.5.2
  procedure
    stored procedures
      REVISE_SALARY, example, 12.3.1
      using DRDA server, 12.3
      with read-only gateway, 11.6
  procedures
    DB2
      DB2INS, sample, G.1
      ORAIND, sample, G.2
  processing time, with GROUPBY, HAVING, WHERE, 12.6.2
  processor requirements, 3.1.1
  profile set, APPC, configuring, 10.9
  protocol
    commit confirm, 1.3.13
    communications and DRDA-specific parameters, 8.2
    communications protocols with Oracle Net, 9.3
    converter, 1.3.3
    definition, 9.3.3
    implicit protocol conversion, 1.3.3
    network, 11.4
    Oracle Net Protocol Adapters, 9.2
    protocol-independent encryption, 1.3.3
    two-phase commit, 11.5.2
  protocols
    IPC, 9.4.2
    SNA, for the DRDA server, 1.5
    TCP/IP
      for the DRDA server, 1.5
      how supported, 1.9.6
      implicit protocol conversion, 1.3.3
  public database link, 10.7.1

## Q

  queries, distributed, 11.5

## R

  RAW data type
    DRDA_DEFAULT_CCSID description, C.4.8
    translating ASCII to EBCDIC, 12.7.1
  read-only gateway
    main topic, 11.6
    option, DRDA_READ_ONLY, C.4.25
  read-only support, changes in this release, 1.9.22
  rebind
    DRDA_DISABLE_CALL, C.4.10
    DRDA_ISOLATION_LEVEL, C.4.16
    DRDA_PACKAGE_COLLID, C.4.20
    DRDA_PACKAGE_CONSTOKEN, C.4.21
    DRDA_PACKAGE_NAME, C.4.22
    DRDA_PACKAGE_OWNER, C.4.23
    DRDA_PACKAGE_SECTIONS, C.4.24
  recovery port number
    DB2/400, 5.3.1
    DB2/OS390, 5.2.1
  recovery user ID and password
    DB2/400, 5.3.3
    DB2/OS390, 5.2.3
    DB2/UDB, 5.4.3
    DB2/VM, 5.5.3
  remote
    computer, 9.3.1
    connections, 11.1.5
    data, 1.3.2
    data access, 1.9.14
    database
      configuration worksheet, E
      copy data from Oracle Database server to DRDA Server database, 11.8
      creating database links, 11.1.1
      DB2/400, 5.3.3
      DB2/OS390, 5.2.3
      DB2/UDB, 5.4.3
      DB2/VM, 5.5.3
      defining a path, 11.1.1
      DRDA gateway package considerations, 10.5
      DRDA_PACKAGE_SECTIONS, C.4.24
      example error message, 15.1.1
      gateway error codes, 30061, RDB not found, 15.3
    DB2 system, 2.5
    DRDA database, DRDA_ISOLATION_LEVEL, C.4.16
    instance, 12.2
    LU definition, 6.4.3.7
    objects, 13.3.1
    Oracle instance
      running a DB2 stored procedure, 12.3
      synonym for calling a stored procedure, 12.2
    Oracle servers, 9.3.2
    procedure, 1.3.9.2
    table, 1.3.4
    transaction program, 3.1.2
    userid and password, 11.1.1
  renamed parameters, 14.3.3
  REPLACE
    command, supported by COPY, 11.8
  replication in heterogeneous environment, 11.7
  requirements
    hardware, 3.1
    software, 3.2
  restrictions, 2.5
  RESULT, 12.3.1
  result sets
    columns in, 1.9.8
    features of the gateway, 1.9.5
  return code, error, 15.1
  REVISE_SALARY
    stored procedure example, 12.3.1
  row length
    known restrictions, 2.5.1
  ROWID
    known restrictions, 2.5.2
    Oracle column, 2.5.2
    with UPDATE or DELETE, 2.5.2

## S

  sample
    files
      gateway initialization, tnsnames.ora, listener.ora, B
      initsid.gtw, 10.4.1
      initsid.ora, 10.4.1
    Gateway Initialization File, initdrdahoa1.ora, B.1
    listener.ora file, B.3
    SQL scripts, 10.5.2
  SAVEPOINT, known restrictions, 2.5.1
  schema privileges - CREATEIN, 5.4.2
  scripts
    dropold.sql, 10.5.2.2
    g4ddtab, 10.5.2.3
    g4ddview.sql, 10.5.2.3
  security
    Advanced Security, 1.3.3
    DRDA_SECURITY_TYPE, C.4.29
    encryption, 9.5
    overview, 13.1
    site autonomy, 1.3.14
    validation for SNA, 6.6, 7.6
    validation for TCP/IP, 13.4
  SELECT
    and array size, 1.9.3
    operation, 12.1
    SQL statement, 12.8.3
    statement
      compensated SQL functions, 12.5.3
      dates, 12.7.5
      fetch reblocking, 12.1.1
      retrieve results sets, 12.8.3
      with read-only gateway, 11.6
  SELECT WHERE SQL clause, 12.7.7
  semantics, 12.6
  server selection, 6.4.3.1, 7.4.1.1
  service port number, DRDA_CONNECT_PARM, C.4.6
  session, connection, 12.4
  set operators
    compatibility, 12.6.3
    EXCEPT, 12.6.3
    INTERSECT, 12.6.3
    MINUS, 12.6.3
    SQL set operators and clauses, 12.6.3
  shift attribute, multi-byte support, D.5
  SID
    choosing a gateway SID, 10.2
    configuring additional DRDA server instances, 10.9
    Gateway System Identifier, defined, 10.2
  Side Information Profile
    communication error, 15.1.4
    definition, 6.3, 7.3
  SIMPLE linkage convention
    DB2INS, sample DB2 stored procedure, G.1
    of DB2 stored procedures, 12.3.2
  site autonomy, 1.3.14
  SNA, 5.4.1
    configuring
      AS/400 communications, 5.3.1
      OS/390 communications, 5.2.1
      VM communications, 5.5.1
    conversation security, 6.7, 7.7
    CPI-C error, 15.1.4
    facilities, 1.9.11
    functions, 1.6
    LU, 13.5.1.1
    protocol
      DRDA server support, 1.5
    remote access, 1.9.14
    security validation
      IBM Communication Server, 7.6
      Microsoft SNA Server or Host Integration Server, 6.6
      versus TCP/IP security, 13.4
    security, DRDA_SECURITY_TYPE, C.4.29
    SECURITY=PROGRAM, 6.7.1, 7.7.1
    SECURITY=SAME, 6.7.2, 7.7.2
    send/receive buffer, C.4.4
    session allocation mode, DRDA_CMSRC_CM_IMMEDIATE, C.4.7
  SNA Server
    connection definition, 6.4.3.4
    CPI-C symbolic destination names, 6.4.3.8
    definitions
      creating side information profiles, 7.3
      creating SNA definitions for SNA Server version 3, 6.4.3
      side information profiles, 6.3
    for Windows NT, 6.3.1
    link service definition, 6.4.3.3
    local LU definition, 6.4.3.5
    mode definition, 6.4.3.6
    remote LU definition, 6.4.3.7
    server selection, 6.4.3.1
    testing the connection, 6.5
  SNA Server for Windows NT
    dependent LUs, 7.3.1
    independent LUs, 7.3.1
    testing the connection, 7.5
  SNACFG command, 6.4.1
  snacfg.ctl file, 6.4.1, 7.3.2.1
  snapshots
    known restrictions, 2.5.2
    Oracle snapshot feature, 11.7.2
  software requirements, 3.2
  sort order
    with ORDERBY, 12.6.2
  SPUFI on DB2/OS390, 10.5.2
  SQL
    main topic, 1.3.5
    ANSI standard, 1.3.5
    clause compatibility, 12.6.3
    clauses
      DELETE, 12.7.7
      INSERT, 12.7.7
      SELECT WHERE, 12.7.7
      UPDATE, 12.7.7
    constructs, Oracle processing, 12.5
    differences in the gateway, 1.7.1
    functions
      and Native Semantics, 12.6
      quick reference list, F
      SUBSTR, 12.6
    ISO standard, 1.3.5
    native DB2, 1.3.8
    passthrough
      described, 12.8
      retrieving results sets example, 12.8.3.1
      using DBMS_HS_PASSTHROUGH.EXECUTE_IMMEDIATE, 12.8.2
    statements
      DB2, 12.8.2
      DRDA_ISOLATION_LEVEL, C.4.16
      passing through gateway, 12.8
      run through the gateway, 11.10
      using JOIN, 12.1
    syntax, 12.7.9
    tracing
      improving performance, 11.10
      tracing errors in the Oracle Database, 15.4.1
  SQL functions
    column functions, 12.5.1
    compatible, defined, 12.5.1
    compensated, defined, 12.5.3
    DB2/400, 12.5.7
    DB2/OS390, 12.5.5
    DB2/UDB, 12.5.6
    DB2/VM, 12.5.8
    that can be disabled, 12.6.2
    that can be enabled, 12.6.1
    translated
      defined, 12.5.2
    with Native Semantics, 12.6.1
  SQL set operators and clauses, 12.6.3
  SQL*Net
    Heterogeneous Services (HS) facility, 9.2
    replaced by Oracle Net, 9.2
  SQL*Plus
    connecting gateway to Oracle integrating server, 9.7.1
    copying data from Oracle server to DRDA Server, 11.8
    extending gateway uses, 1.8.1
    introduction, 1.3.12
  sqlstate, mapped sqlstate errors, 15.2
  stability, of cursor, DRDA_ISOLATION_LEVEL, C.4.16
  Startup Shell Script
    migration, 14.1.2
  statements
    CREATE DATABASE LINK, 11.1.1
    CREATE DATABASE, client/server configuration, D.2
    DB2 CREATE TABLE, 1.3.8
    DDL
      nonqueries supported by gateway passthrough, 12.8
      number of rows affected by passthrough, 12.8.2
    DELETE
      and TO_DATE function, 12.7.5
      nonqueries supported by gateway passthrough, 12.8
    DROP DATABASE LINK, 11.1.3
    GRANT, 10.7.2
    INSERT
      and TO_DATE function, 12.7.5
      nonqueries supported by gateway passthrough, 12.8
    passing SQL through gateway, 12.8
    PREPARE TRANSACTION, two-phase commit, 11.5.2
    SELECT
      and TO_DATE function, 12.7.5
      compensated SQL functions, 12.5.3
      fetch reblocking, array size, 12.1.1
      retrieve results sets, 12.8.3
      with read-only gateway, 11.6
    SQL
      DB2, 12.8.2
      JOIN, 12.1
      SELECT, 12.8.3
    UPDATE
      and TO_DATE function, 12.7.5
      nonqueries supported by gateway passthrough, 12.8
  stored procedure
    creating on DB2, 12.3.1
    DB2
      considerations for use, 12.3.2
      native to DRDA server, 12.3
      with read-only gateway, 11.6
    DB2INS, sample, G.1
    extended database services, 1.3.2
    GTW$_BIND_PKG, 10.4.4
    native DB2, 1.3.9.2
    Oracle and non-Oracle, 1.3.9
    Oracle Database 10g server
      using, 12.2
    Oracle database server
      local instance, 12.2
      PL/SQL, 12.2
      remote instance, 12.2
    Oracle, description, 1.3.9.1
    ORAIND, sample, G.2
    restriction, 2.5.1
    REVISE_SALARY, example, 12.3.1
    usage, C.4.10
    using DRDA server, 12.3
  string concatenation, known restrictions, 2.5.1
  string index, with Native Semantics, 12.6
  Structured Query Language, also see SQL, 1.2.1
  SUBSTR
    SQL function
      known restrictions, 2.5.1
      Oracle implementation permits negative values, 12.6
      with Native Semantics, 2.5.1
  synonym
    feature, 11.4
    for location transparency, 12.2
    how the gateway works, 1.7
  system privileges - BINDADD and BINDAGENT
    configuration worksheet, E
    DB2/OS390, 5.2.2
    DB2/VM, 5.5.2

## T

  table
    create a table in DB2, 12.8.2.1
    insert a row into a DB2 table, 12.8.2.1
  TABLE_PRIVILEGES view, A.2.17
  tables
    ORACLE2PC, 10.5.1.2, 10.5.2.5
    ORACLE2PC, distributed transactions, 11.5.3
    ORADRDA.ORACLE2PC, two-phase commit, 11.5.2
  tailoring
    initsid.ora file, 10.4.2
  TCP/IP
    affecting memory requirements, 3.1.2
    concurrent connections, 3.1.2
    configuration chapter, 8
    configuration worksheet, E
    configuring
      for AS/400, 5.3.1
      for OS/390, 5.2.1
      for VM, 5.5.1
      to use DNS, 8.2
      using DRDA_CONNECT_PARM parameter, 8.2
    database link behavior, 12.4
    default port number, 9.4.2
    DRDA_CONNECT_PARM, C.4.6
    facilities, 1.9.11
    format, gateway initialization file parameter, C.4.6
    functions, 1.6
    gateway architecture, connecting to DRDA Server, 1.5
    known restrictions, DRDA Network Interfaces, 2.5.1
    modifying tnsnames.ora in Oracle Net, 9.4.2
    protocol
      access across multiple networks - transparency, 1.3.1
      DRDA server support, 1.5
      implicit protocol conversion, 1.3.3
    remote access, 1.9.14
    sample Oracle Net listener.ora file, B.3
    security validation, 13.4
    support, 1.9.6
    you must choose either SNA or TCP/IP for the Networking Interface, 8.2
  terminology defined, 1.4
  tg4drdasnacommsvr subdirectory, sample SNA Server definitions, 7.3.2.1, 7.3.2.1
  tg4drdasnamssna subdirectory, sample SNA Server definitions, 6.4.1
  TIME data type, 12.7.4.1
  time operations, 12.7.4
  TIMESTAMP data type, 12.7.4.1
  TNSNAMES.ORA
    changes to, during migration problems, 14.2
  tnsnames.ora
    adding a gateway service name, 9.4.2, 9.4.2
    configuring additional DRDA Server instances, 10.9
    connect descriptor, 11.1.1
    using the HS facilities, 14.5
  TO_DATE function
    Oracle function preprocessed in SQL, 12.7.7
    processing DATE data, 12.7.4.2
    twenty-first century dates, 12.7.5
  token
    error tokens, 15.1.3
    package consistency, DRDA_PACKAGE_CONSTOKEN, C.4.21
  trace control, C.4.39
  TRACE_LEVEL parameter, C.4.41
  tracing
    code, C.4.41
    LOG_DESTINATION, C.4.36
    ORACLE_DRDA_TRACE, C.4.40
    SQL statements, 11.10
  trade-off, Native Semantics, 12.6
  transaction mode, read-only, DRDA_READ_ONLY, C.4.25
  transactions
    CICS, 12.3.2
    IMS, 12.3.2
  transform
    character set transforms with multi-byte support, D.5
    not required for DRDA Server, D.5
  transparency
    and performance, 12.6
    main topic, gateway transparency, 1.3.1
  triggers for Oracle Database 10g server, 11.7.1
  TSO, 5.2
  two-phase commit
    ORACLE2PC table
      DB2/400, 5.3.2
      DB2/OS390, 5.2.2
      DB2/UDB, 5.4.2
      DB2/VM, 5.5.2
    protection, 1.3.2
    transactions, distributed queries, 11.5.2
    unsupported statement, 11.5.2

## U

  UNION
    capability, 1.3.2
    operator, 12.6.3
  UNION ALL
    operator, 12.6.3
  UPDATE
    known restrictions, 2.5.2
    operation, 12.1
    SQL clause, 12.7.7
    statement
      dates, 12.7.5
      native SQL passthrough, 12.8
      transaction semantics, 1.7.1
    with read-only gateway, 11.6
  upgrading, defined, 14.1
  user privileges, 12.9
  USER_CATALOG view, A.2.18
  USER_COL_COMMENTS view, A.2.19
  USER_CONS_COLUMNS view, A.2.21
  USER_CONSTRAINTS view, A.2.20
  USER_DB_LINKS data dictionary view, 11.1.4
  USER_INDEXES view, A.2.22
  USER_OBJECTS view, A.2.23
  USER_SYNONYMS view, A.2.24
  USER_TAB_COLUMNS view, A.2.26
  USER_TAB_COMMENTS view, A.2.27
  USER_TABLES view, A.2.25
  USER_USERS view, A.2.28
  USER_VIEWS view, A.2.29
  userid mapping
    DB2/400, 13.5.1.3
    DB2/OS390, 13.5.1.1
    DB2/VM, 13.5.1.2
    security, 13.5.1
  userid translation
    DB2, 13.5.1.2
  USING clause, 11.1.1

## V

  VALUES clause, 12.7.7
  VARCHAR data type, 12.7.2
  variable
    bind, 12.8
    input bind, 12.7.4.2
  view
    catalog
      DB2/400, 12.9.1
      DB2/OS390, 12.9.1
      DB2/UDB, 12.9.1
      DB2/VM, 12.9.1
    creating, 10.7.2
    data dictionary, 12.9
  VSAM file, 12.3.2
  VTAM
    DB2/OS390, 5.2
    DB2/VM VTAM configuring, 5.5.1

## W

  WHERE clause
    compatible for all versions of DRDA Server, 12.6.3
    SQL limitations, Oracle ROWID column, 2.5.2
  WHERE CURRENT OF CURSOR clause, ROWID column, 2.5.2
  WHERE function, 12.6.2
  wireless communication, 1.3.3
  workarounds, 2.4

## Z

  zoned decimal operations, 12.7.10